﻿CREATE TABLE [dbo].[ClinRecipeResultData]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
	[ClinRecipeId] INT NULL,
    [HosPayId] NVARCHAR(50) NULL, 
    [FeeType] NVARCHAR(50) NULL, 
    [TotalAmt] NVARCHAR(50) NULL, 
    [SelfAmt] NVARCHAR(50) NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'缴费流水号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeResultData',
    @level2type = N'COLUMN',
    @level2name = N'HosPayId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'发票分类',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeResultData',
    @level2type = N'COLUMN',
    @level2name = N'FeeType'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'分类总金额',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeResultData',
    @level2type = N'COLUMN',
    @level2name = N'TotalAmt'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'分类自费金额',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeResultData',
    @level2type = N'COLUMN',
    @level2name = N'SelfAmt'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'ClinRecipe.Id',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeResultData',
    @level2type = N'COLUMN',
    @level2name = N'ClinRecipeId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自增长',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeResultData',
    @level2type = N'COLUMN',
    @level2name = N'Id'